CREATE   PROCEDURE [dbo].[asi_PrcQueryPriceVersionDetailOwner]
    @priceSheetKey uniqueidentifier,
    @priceSheetVersionKey uniqueidentifier,
    @productKey uniqueidentifier,
    @currencyCode nchar(3)
    AS
BEGIN
    SELECT psv.PriceSheetVersionKey, psv.Version, psv.BeginDate
    FROM
    PriceSheetVersion psv
    INNER JOIN PriceVersionDetail pvd ON psv.PriceSheetVersionKey = pvd.PriceSheetVersionKey
    INNER JOIN PriceDetail pd ON pvd.PriceDetailKey = pd.PriceDetailKey
    WHERE psv.PriceSheetKey=@priceSheetKey
    AND pd.ProductKey=@productKey
    AND pd.CurrencyCode=@currencyCode
    AND pvd.IsVersionOwner=1
    AND psv.Version <= (SELECT psv1.Version FROM PriceSheetVersion psv1 WHERE PriceSheetVersionKey = @priceSheetVersionKey)
    ORDER BY psv.Version DESC
END

GO